USE NutritionTracker
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE ID = object_id(N'AppUser_MeasurementUnit_Read_List') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
	DROP PROCEDURE AppUser_MeasurementUnit_Read_List
GO
CREATE PROC	AppUser_MeasurementUnit_Read_List
(
@AppUserID	INT
)
AS
BEGIN
	SET NOCOUNT ON
	
	SELECT		AppUserID,
			MeasurementTypeID,
			MeasurementUnitID	
	FROM		AppUser_MeasurementUnit
	WHERE		AppUserID = @AppUserID

	SET NOCOUNT OFF
END
GO
GRANT EXECUTE ON AppUser_MeasurementUnit_Read_List TO NUTRKR_WEB
GO